1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10
11 namespace SoftQuanLyNhaHang.Views
12 {
13 public partial class uctBaoCao_KetThucNgayLamViec : UserControl
14 {
15 public uctBaoCao_KetThucNgayLamViec()
16 {
17 InitializeComponent();
18 //this.tableLayoutPanel1.CellPaint += tableLayoutPanel1_CellPaint;
19
20
21 }
22
23 //public static uctKho uctK = new uctKho();
24 public static uctBaoCao_KetThucNgayLamViec uctBc_Ktnlv = new uctBaoCao_KetThucNgayLamViec();
25
26
27 double tongThuBanHang_VaCongNoThu = 0;
28 double tongChiNhapHang_VaCongNoChi = 0;
29
30 DateTime _getNgayLamViec = DateTime.Now;
31
32 private void uctBaoCao_KetThucNgayLamViec_Load(object sender, EventArgs e)
33 {
34 textBox1.Focus();
35 this.KetThucNgayLamViec(_getNgayLamViec);
36
37 }
38
39 private void KetThucNgayLamViec(DateTime ngayLamViec)
40 {
41 txtNgayLV.Text = CauHinhHeThong.Format_HienThiNgayThangNam(ngayLamViec.ToString(), false);
42 //ban hang
43 DataTable dtKtNLV_DaBan = new DataTable();
44 dtKtNLV_DaBan = Controllers.BaoCaoCtrl.uctBaoCao_Gets_KetThucNgayLamViec(ngayLamViec, "MuaHang", "").Tables[0];
45
46
47 if (dtKtNLV_DaBan.Rows.Count > 0)
48 {
49 double tongDonHang_DaBan = 0;
50 double tongThue_DaBan = 0;
51 double tongSoGiaoDich_DaBan = 0;
52
53
54 tongDonHang_DaBan = CauHinhHeThong.Format_SoDeTinhToan(dtKtNLV_DaBan.Rows[0]["TongDonHang"].ToString(), false);
55 tongThue_DaBan = CauHinhHeThong.Format_SoDeTinhToan(dtKtNLV_DaBan.Rows[0]["TongThue"].ToString(), false);
56 tongSoGiaoDich_DaBan = CauHinhHeThong.Format_SoDeTinhToan(dtKtNLV_DaBan.Rows[0]["SoLuongGiaoDich"].ToString(), false);
57
58 txtTongDonBanHang.Text = CauHinhHeThong.Format_SoDeHienThi(tongDonHang_DaBan, true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
59
60 txtTongDonHangKhongChiuThueBanHang.Text = CauHinhHeThong.Format_SoDeHienThi((tongDonHang_DaBan - tongThue_DaBan), true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
61
62 txtTongThueBanHang.Text = CauHinhHeThong.Format_SoDeHienThi(tongThue_DaBan, true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
63
64 txtSoLuongGiaDichBanHang.Text = CauHinhHeThong.Format_SoDeHienThi(tongSoGiaoDich_DaBan, false);
65
66 if (tongSoGiaoDich_DaBan != 0)
67 {
68 txtSoTienTbBanHang.Text = CauHinhHeThong.Format_SoDeHienThi((tongDonHang_DaBan / tongSoGiaoDich_DaBan), true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
69 }
70 else
71 {
72 txtSoTienTbBanHang.Text = "0 " + CauHinhHeThong.KI_HIEU_TIEN_TE;
73 }
74
75 }
76 else
77 {
78 }
79
80 //dat hang
81 DataTable dtKtNLV_DatHang = new DataTable();
82 dtKtNLV_DatHang = Controllers.BaoCaoCtrl.uctBaoCao_Gets_KetThucNgayLamViec(ngayLamViec, "DatHang", "").Tables[0];
83
84 if (dtKtNLV_DatHang.Rows.Count > 0)
85 {
86 double tongDonHang_DatHang = 0;
87 double tongThue_DatHang = 0;
88 double tongSoGiaoDich_DatHang = 0;
89
90
91 tongDonHang_DatHang = CauHinhHeThong.Format_SoDeTinhToan(dtKtNLV_DatHang.Rows[0]["TongDonHang"].ToString(), false);
92 tongThue_DatHang = CauHinhHeThong.Format_SoDeTinhToan(dtKtNLV_DatHang.Rows[0]["TongThue"].ToString(), false);
93 tongSoGiaoDich_DatHang = CauHinhHeThong.Format_SoDeTinhToan(dtKtNLV_DatHang.Rows[0]["SoLuongGiaoDich"].ToString(), false);
94
95
96 txtDonDatHang.Text = CauHinhHeThong.Format_SoDeHienThi(tongDonHang_DatHang, true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
97
98 txtTongThueDatHang.Text = CauHinhHeThong.Format_SoDeHienThi(tongThue_DatHang, true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
99
100 txtSoLuongDonDatHang.Text = CauHinhHeThong.Format_SoDeHienThi(tongSoGiaoDich_DatHang, false);
101
102 //txtTongTienTbDatHang.Text = CauHinhHeThong.Format_SoDeHienThi((tongDonHang_DatHang / tongSoGiaoDich_DatHang), true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
103
104 }
105 else
106 {
107
108 }
109
110 //tra hang
111 DataTable dtKtNLV_TraHang = new DataTable();
112 dtKtNLV_TraHang = Controllers.BaoCaoCtrl.uctBaoCao_Gets_KetThucNgayLamViec(ngayLamViec, "TraHang", "").Tables[0];
113
114 if (dtKtNLV_DatHang.Rows.Count > 0)
115 {
116 double tongDonHang_TraHang = 0;
117 double tongThue_TraHang = 0;
118 double tongSoGiaoDich_TraHang = 0;
119
120
121 tongDonHang_TraHang = CauHinhHeThong.Format_SoDeTinhToan(dtKtNLV_TraHang.Rows[0]["TongDonHang"].ToString(), false);
122 tongThue_TraHang = CauHinhHeThong.Format_SoDeTinhToan(dtKtNLV_TraHang.Rows[0]["TongThue"].ToString(), false);
123 tongSoGiaoDich_TraHang = CauHinhHeThong.Format_SoDeTinhToan(dtKtNLV_TraHang.Rows[0]["SoLuongGiaoDich"].ToString(), false);
124
125 txtTongDonTraHang.Text = CauHinhHeThong.Format_SoDeHienThi(tongDonHang_TraHang, true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
126
127 //txtTongTienDonTraHangKhongThue.Text = CauHinhHeThong.Format_SoDeHienThi((tongDonHang_TraHang - tongThue_TraHang), true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
128
129 txtTongThueTraHang.Text = CauHinhHeThong.Format_SoDeHienThi(tongThue_TraHang, true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
130
131 txtSoLuongTraHang.Text = CauHinhHeThong.Format_SoDeHienThi(tongSoGiaoDich_TraHang, false);
132
133
134 }
135 else
136 {
137
138 }
139
140
141 //nhap hang
142 DataTable dtNhapHang_DaNhap = new DataTable();
143 dtNhapHang_DaNhap = Controllers.BaoCaoCtrl.uctBaoCao_Gets_KetThucNgayLamViec(ngayLamViec, "", "NhapHang").Tables[1];
144
145 if (dtNhapHang_DaNhap.Rows.Count > 0)
146 {
147 double tongDonHang_Nhap = 0;
148 double tongThue_Nhap = 0;
149 double tongSoGiaoDich_Nhap = 0;
150
151
152 tongDonHang_Nhap = CauHinhHeThong.Format_SoDeTinhToan(dtNhapHang_DaNhap.Rows[0]["TongDonNhapHang"].ToString(), false);
153 tongThue_Nhap = CauHinhHeThong.Format_SoDeTinhToan(dtNhapHang_DaNhap.Rows[0]["TongThueNhapHang"].ToString(), false);
154 tongSoGiaoDich_Nhap = CauHinhHeThong.Format_SoDeTinhToan(dtNhapHang_DaNhap.Rows[0]["SoLuongGiaoDichNhapHang"].ToString(), false);
155
156 txtTongDonNhapHang.Text = CauHinhHeThong.Format_SoDeHienThi(tongDonHang_Nhap, true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
157
158 txtTongDonNhapKhongThue.Text = CauHinhHeThong.Format_SoDeHienThi((tongDonHang_Nhap - tongThue_Nhap), true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
159
160 txtTongThueNhap.Text = CauHinhHeThong.Format_SoDeHienThi(tongThue_Nhap, true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
161
162 txtSoLuongNhap.Text = CauHinhHeThong.Format_SoDeHienThi(tongSoGiaoDich_Nhap, false);
163
164 }
165 else
166 {
167 }
168
169 //tam dung
170 DataTable dtNhapHang_TamDung = new DataTable();
171 dtNhapHang_TamDung = Controllers.BaoCaoCtrl.uctBaoCao_Gets_KetThucNgayLamViec(ngayLamViec, "", "TamDung").Tables[1];
172
173 if (dtNhapHang_TamDung.Rows.Count > 0)
174 {
175 double tongDonHang_NhapHang_TamDung = 0;
176 double tongThue_NhapHang_TamDung = 0;
177 double tongSoGiaoDich_NhapHang_TamDung = 0;
178
179
180 tongDonHang_NhapHang_TamDung = CauHinhHeThong.Format_SoDeTinhToan(dtNhapHang_TamDung.Rows[0]["TongDonNhapHang"].ToString(), false);
181 tongThue_NhapHang_TamDung = CauHinhHeThong.Format_SoDeTinhToan(dtNhapHang_TamDung.Rows[0]["TongThueNhapHang"].ToString(), false);
182 tongSoGiaoDich_NhapHang_TamDung = CauHinhHeThong.Format_SoDeTinhToan(dtNhapHang_TamDung.Rows[0]["SoLuongGiaoDichNhapHang"].ToString(), false);
183
184
185 txtTongDonNH_Dathang.Text = CauHinhHeThong.Format_SoDeHienThi(tongDonHang_NhapHang_TamDung, true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
186
187 txtTongDonNH_KhongChiuThue.Text = CauHinhHeThong.Format_SoDeHienThi((tongDonHang_NhapHang_TamDung - tongThue_NhapHang_TamDung), true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
188
189 txtTongDonNH_TongThue.Text = CauHinhHeThong.Format_SoDeHienThi(tongThue_NhapHang_TamDung, true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
190
191 txtTongDonNH_SLDat.Text = CauHinhHeThong.Format_SoDeHienThi(tongSoGiaoDich_NhapHang_TamDung, false);
192
193 }
194 else
195 {
196 }
197
198 //huy don hang
199 DataTable dtNhapHang_HuyDonHang = new DataTable();
200 dtNhapHang_HuyDonHang = Controllers.BaoCaoCtrl.uctBaoCao_Gets_KetThucNgayLamViec(ngayLamViec, "", "HuyDonHang").Tables[1];
201
202 if (dtNhapHang_HuyDonHang.Rows.Count > 0)
203 {
204 double tongDonHang_NhapHang_HuyDonHang = 0;
205 double tongThue_NhapHang_HuyDonHang = 0;
206 double tongSoGiaoDich_NhapHang_HuyDonHang = 0;
207
208
209 tongDonHang_NhapHang_HuyDonHang = CauHinhHeThong.Format_SoDeTinhToan(dtNhapHang_HuyDonHang.Rows[0]["TongDonNhapHang"].ToString(), false);
210 tongThue_NhapHang_HuyDonHang = CauHinhHeThong.Format_SoDeTinhToan(dtNhapHang_HuyDonHang.Rows[0]["TongThueNhapHang"].ToString(), false);
211 tongSoGiaoDich_NhapHang_HuyDonHang = CauHinhHeThong.Format_SoDeTinhToan(dtNhapHang_HuyDonHang.Rows[0]["SoLuongGiaoDichNhapHang"].ToString(), false);
212
213
214
215 txtTongDonTraHang_NhapHang.Text = CauHinhHeThong.Format_SoDeHienThi(tongDonHang_NhapHang_HuyDonHang, true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
216
217 txtTongDHKhongThue_TraHang.Text = CauHinhHeThong.Format_SoDeHienThi((tongDonHang_NhapHang_HuyDonHang - tongThue_NhapHang_HuyDonHang), true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
218
219 txtTongThue_TraHang.Text = CauHinhHeThong.Format_SoDeHienThi(tongThue_NhapHang_HuyDonHang, true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
220
221 txtSoLuongTraHangNhapHang.Text = CauHinhHeThong.Format_SoDeHienThi(tongSoGiaoDich_NhapHang_HuyDonHang, false);
222
223 }
224 else
225 {
226 }
227
228
229 //cong no thu chi
230 double congNoThu = 0;
231 double congNoChi = 0;
232
233 DataTable dtThuCn = new DataTable();
234
235 dtThuCn = Controllers.BaoCaoCtrl.uctBaoCao_Gets_KetThucNgayLamViec(ngayLamViec, "", "").Tables[2];
236
237 if (dtThuCn.Rows.Count > 0)
238 {
239 congNoThu = CauHinhHeThong.Format_SoDeTinhToan(dtThuCn.Rows[0]["TongCongNoThu"].ToString(), false);
240 tongThuBanHang_VaCongNoThu = CauHinhHeThong.Format_SoDeTinhToan(dtThuCn.Rows[0]["TongTienThuBanHang"].ToString(), false);
241 }
242 else
243 {
244 congNoThu = 0;
245 tongThuBanHang_VaCongNoThu = 0;
246 }
247
248 double tongCongNoThu = tongThuBanHang_VaCongNoThu + congNoThu;
249
250 txtCongNoThu.Text = CauHinhHeThong.Format_SoDeHienThi(tongCongNoThu, true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
251
252 DataTable dtChiCn = new DataTable();
253 dtChiCn = Controllers.BaoCaoCtrl.uctBaoCao_Gets_KetThucNgayLamViec(ngayLamViec, "", "").Tables[3];
254
255 if (dtChiCn.Rows.Count > 0)
256 {
257 congNoChi = CauHinhHeThong.Format_SoDeTinhToan(dtChiCn.Rows[0]["TongCongNoChi"].ToString(), false);
258 tongChiNhapHang_VaCongNoChi = CauHinhHeThong.Format_SoDeTinhToan(dtChiCn.Rows[0]["TongTienDaThanhToanNhapHang"].ToString(), false);
259 }
260 else
261 {
262 congNoChi = 0;
263 tongChiNhapHang_VaCongNoChi = 0;
264 }
265
266 double tongCongNoChi = tongChiNhapHang_VaCongNoChi + congNoChi;
267
268 txtCongNoChi.Text = CauHinhHeThong.Format_SoDeHienThi(tongCongNoChi, true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
269
270 double tongDoanhThu = (tongThuBanHang_VaCongNoThu + congNoThu) - (congNoChi + tongChiNhapHang_VaCongNoChi);
271
272 txtDoanhThu.Text = CauHinhHeThong.Format_SoDeHienThi(tongDoanhThu, true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
273
274 DataTable dtDtLoiNhuan = new DataTable();
275 dtDtLoiNhuan = Controllers.BaoCaoCtrl.uctBaoCao_Gets_KetThucNgayLamViec(ngayLamViec, "", "").Tables[4];
276 if (dtDtLoiNhuan.Rows.Count > 0)
277 {
278 double tongGiaNhap = 0;
279 tongGiaNhap = CauHinhHeThong.Format_SoDeTinhToan(dtDtLoiNhuan.Rows[0]["TongGiaNhapHang"].ToString(), false);
280
281 double LoiNhuan = tongThuBanHang_VaCongNoThu - tongGiaNhap;
282
283 txtLoiNhuan.Text = CauHinhHeThong.Format_SoDeHienThi(LoiNhuan, true) + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
284 }
285 else
286 {
287 txtLoiNhuan.Text = "0" + " " + CauHinhHeThong.KI_HIEU_TIEN_TE;
288 }
289
290 }
291
292 private void tableLayoutPanel1_CellPaint(object sender, TableLayoutCellPaintEventArgs e)
293 {
294 //e.Graphics.DrawLine(Pens.Black, e.CellBounds.Location, new Point(e.CellBounds.Right, e.CellBounds.Top));
295 }
296
297 private void linkLabel_NgayTiepTheo_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
298 {
299 _getNgayLamViec = _getNgayLamViec.AddDays(+1);
300 this.KetThucNgayLamViec(_getNgayLamViec);
301 }
302
303 private void linkLabel_NgayHomTruoc_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
304 {
305 _getNgayLamViec = _getNgayLamViec.AddDays(-1);
306 this.KetThucNgayLamViec(_getNgayLamViec);
307 }
308
309 private void btnLoadLai_Click(object sender, EventArgs e)
310 {
311 this.KetThucNgayLamViec(_getNgayLamViec);
312 }
313
314 public void LoadLai_uctBaoCao_KetThucNgayLamViec()
315 {
316 this.KetThucNgayLamViec(_getNgayLamViec);
317 }
318
319 }
320 }